BEGIN TRANSACTION
GO
	UPDATE  data_SalesDetail SET Amount = Round(Weight * UnitRate, 0) WHERE (Amount=0)
GO
COMMIT

------------------------------------------

/****** Object:  View [dbo].[vw_StockDetail]    Script Date: 07/31/2026 11:29:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER VIEW [dbo].[vw_StockDetail]
AS
SELECT     dbo.data_SalesInfo.SalesID, dbo.data_SalesInfo.SalesDate, dbo.data_SalesInfo.SalesVNo, dbo.data_SalesInfo.Type, dbo.data_SalesInfo.Remarks, dbo.data_SalesInfo.AccountVoucherID, 
                      dbo.data_SalesInfo.CashVoucherID, dbo.data_SalesInfo.CustomerName, dbo.data_SalesInfo.ReadOnly, dbo.data_SalesInfo.Paid, dbo.data_SalesInfo.SessionID, dbo.data_SalesInfo.PartyID, 
                      ISNULL(dbo.data_SalesInfo.CustomerName, dbo.vw_PartiesInfo.PartyTitle) AS PartyTitle, dbo.vw_ProductsInfo.GroupID, dbo.vw_ProductsInfo.CategoryID, dbo.data_SalesDetail.ProductID, 
                      dbo.vw_ProductsInfo.ProductTitle, ISNULL(dbo.data_SalesDetail.Quantity, 0) AS Quantity, ISNULL(dbo.data_SalesDetail.Weight, 0) AS Weight, dbo.data_SalesDetail.UnitRate, 
                      ROUND(dbo.data_SalesDetail.Weight * dbo.data_SalesDetail.UnitRate, 0) AS Amount, dbo.data_SalesDetail.Remarks AS DetailRemarks, dbo.vw_ProductsInfo.UnitPrice, 
                      dbo.vw_ProductsInfo.UnitPrice2, dbo.vw_ProductsInfo.SalePrice, dbo.vw_ProductsInfo.SalePrice2
FROM         dbo.data_SalesInfo INNER JOIN
                      dbo.data_SalesDetail ON dbo.data_SalesInfo.SalesID = dbo.data_SalesDetail.SalesID LEFT OUTER JOIN
                      dbo.vw_PartiesInfo ON dbo.data_SalesInfo.PartyID = dbo.vw_PartiesInfo.PartyID LEFT OUTER JOIN
                      dbo.vw_ProductsInfo ON dbo.data_SalesDetail.ProductID = dbo.vw_ProductsInfo.ProductID
WHERE     (dbo.data_SalesInfo.SalesID > 0)

------------------------------------------

/****** Object:  View [dbo].[vw_ProductWiseCost]    Script Date: 07/31/2026 11:33:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER VIEW [dbo].[vw_ProductWiseCost]
AS
SELECT     SalesID, SalesDate, SalesVNo, SessionID, PartyID, PartyTitle, Type, GroupID, CategoryID, ProductID, ProductTitle, SUM(Quantity) AS InQTY, 0 AS OutQTY, SUM(Weight) AS InWeight, 0 AS OutWeight,
                       AVG(UnitRate) AS Rate, SUM(Amount) AS InAmount, 0 AS OutAmount, UnitPrice, UnitPrice2, SalePrice, SalePrice2
FROM         dbo.vw_StockDetail
WHERE     (Type IN ('SALES', 'PRETURN'))
GROUP BY SalesID, SalesDate, SalesVNo, Type, SessionID, PartyID, PartyTitle, GroupID, CategoryID, ProductID, ProductTitle, UnitPrice, UnitPrice2, SalePrice, SalePrice2
UNION ALL
SELECT     SalesID, SalesDate, SalesVNo, SessionID, PartyID, PartyTitle, Type, GroupID, CategoryID, ProductID, ProductTitle, 0 AS InQTY, SUM(Quantity) AS OutQTY, 0 AS InWeight, SUM(Weight) AS OutWeight,
                       AVG(UnitRate) AS Rate, 0 AS InAmount, SUM(Amount) AS OutAmount, UnitPrice, UnitPrice2, SalePrice, SalePrice2
FROM         dbo.vw_StockDetail AS vw_StockDetail_1
WHERE     (Type IN ('PURCHASE', 'SRETURN'))
GROUP BY SalesID, SalesDate, SalesVNo, Type, SessionID, PartyID, PartyTitle, GroupID, CategoryID, ProductID, ProductTitle, UnitPrice, UnitPrice2, SalePrice, SalePrice2